USE [QuanLyKho]
GO

DROP TABLE LenhSanXuat

GO

CREATE TABLE [dbo].[LenhSanXuat](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[MaSanPham] [nvarchar](20) NULL,
	[NgayLapLenh] [datetime] NULL,
	[NguoiLapLenh] [nvarchar](200) NULL,
	[SoLuong] [float] NULL,
	[NgayGuiLenh] [datetime] NULL,
	[NgaySuaLenh] [datetime] NULL,
	[NgayDuyetLenh] [datetime] NULL,
	[TrangThai] [int] NULL,
	[NgayChungTu] [datetime] NULL,
	[NgayHoachToan] [datetime] NULL,
	[SoChungTu] [nvarchar](80) NULL,
	[GhiChu] [nvarchar](500) NULL,
	[KhoDen] [nvarchar](200) NULL,
	[KhoDi] [nvarchar](200) NULL,
 CONSTRAINT [PK_LenhSanXuat] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO


